package com.groupies;

/**
 * @author GroupiesM
 * @date 2021/06/09
 * @introduction
 */
public class KtrSource {
    public static String ktrSourceTest ="<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n" +
                                                "<transformation>\n" +
                                                "  <info>\n" +
                                                "    <name>${TABLE_NAME}</name>\n" +
                                                "    <description />\n" +
                                                "    <extended_description />\n" +
                                                "    <trans_version />\n" +
                                                "    <trans_type>Normal</trans_type>\n" +
                                                "    <trans_status>0</trans_status>\n" +
                                                "    <directory>/</directory>\n" +
                                                "    <parameters>\n" +
                                                "    </parameters>\n" +
                                                "    <log>\n" +
                                                "      <trans-log-table>\n" +
                                                "        <connection />\n" +
                                                "        <schema />\n" +
                                                "        <table />\n" +
                                                "        <size_limit_lines />\n" +
                                                "        <interval />\n" +
                                                "        <timeout_days />\n" +
                                                "        <field>\n" +
                                                "          <id>ID_BATCH</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>ID_BATCH</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>CHANNEL_ID</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>CHANNEL_ID</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>TRANSNAME</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>TRANSNAME</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>STATUS</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>STATUS</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_READ</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_READ</name>\n" +
                                                "          <subject />\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_WRITTEN</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_WRITTEN</name>\n" +
                                                "          <subject />\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_UPDATED</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_UPDATED</name>\n" +
                                                "          <subject />\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_INPUT</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_INPUT</name>\n" +
                                                "          <subject />\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_OUTPUT</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_OUTPUT</name>\n" +
                                                "          <subject />\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_REJECTED</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_REJECTED</name>\n" +
                                                "          <subject />\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>ERRORS</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>ERRORS</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>STARTDATE</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>STARTDATE</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>ENDDATE</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>ENDDATE</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LOGDATE</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LOGDATE</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>DEPDATE</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>DEPDATE</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>REPLAYDATE</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>REPLAYDATE</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LOG_FIELD</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LOG_FIELD</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>EXECUTING_SERVER</id>\n" +
                                                "          <enabled>N</enabled>\n" +
                                                "          <name>EXECUTING_SERVER</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>EXECUTING_USER</id>\n" +
                                                "          <enabled>N</enabled>\n" +
                                                "          <name>EXECUTING_USER</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>CLIENT</id>\n" +
                                                "          <enabled>N</enabled>\n" +
                                                "          <name>CLIENT</name>\n" +
                                                "        </field>\n" +
                                                "      </trans-log-table>\n" +
                                                "      <perf-log-table>\n" +
                                                "        <connection />\n" +
                                                "        <schema />\n" +
                                                "        <table />\n" +
                                                "        <interval />\n" +
                                                "        <timeout_days />\n" +
                                                "        <field>\n" +
                                                "          <id>ID_BATCH</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>ID_BATCH</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>SEQ_NR</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>SEQ_NR</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LOGDATE</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LOGDATE</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>TRANSNAME</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>TRANSNAME</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>STEPNAME</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>STEPNAME</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>STEP_COPY</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>STEP_COPY</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_READ</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_READ</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_WRITTEN</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_WRITTEN</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_UPDATED</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_UPDATED</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_INPUT</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_INPUT</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_OUTPUT</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_OUTPUT</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_REJECTED</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_REJECTED</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>ERRORS</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>ERRORS</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>INPUT_BUFFER_ROWS</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>INPUT_BUFFER_ROWS</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>OUTPUT_BUFFER_ROWS</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>OUTPUT_BUFFER_ROWS</name>\n" +
                                                "        </field>\n" +
                                                "      </perf-log-table>\n" +
                                                "      <channel-log-table>\n" +
                                                "        <connection />\n" +
                                                "        <schema />\n" +
                                                "        <table />\n" +
                                                "        <timeout_days />\n" +
                                                "        <field>\n" +
                                                "          <id>ID_BATCH</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>ID_BATCH</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>CHANNEL_ID</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>CHANNEL_ID</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LOG_DATE</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LOG_DATE</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LOGGING_OBJECT_TYPE</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LOGGING_OBJECT_TYPE</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>OBJECT_NAME</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>OBJECT_NAME</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>OBJECT_COPY</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>OBJECT_COPY</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>REPOSITORY_DIRECTORY</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>REPOSITORY_DIRECTORY</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>FILENAME</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>FILENAME</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>OBJECT_ID</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>OBJECT_ID</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>OBJECT_REVISION</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>OBJECT_REVISION</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>PARENT_CHANNEL_ID</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>PARENT_CHANNEL_ID</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>ROOT_CHANNEL_ID</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>ROOT_CHANNEL_ID</name>\n" +
                                                "        </field>\n" +
                                                "      </channel-log-table>\n" +
                                                "      <step-log-table>\n" +
                                                "        <connection />\n" +
                                                "        <schema />\n" +
                                                "        <table />\n" +
                                                "        <timeout_days />\n" +
                                                "        <field>\n" +
                                                "          <id>ID_BATCH</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>ID_BATCH</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>CHANNEL_ID</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>CHANNEL_ID</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LOG_DATE</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LOG_DATE</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>TRANSNAME</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>TRANSNAME</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>STEPNAME</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>STEPNAME</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>STEP_COPY</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>STEP_COPY</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_READ</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_READ</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_WRITTEN</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_WRITTEN</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_UPDATED</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_UPDATED</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_INPUT</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_INPUT</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_OUTPUT</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_OUTPUT</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LINES_REJECTED</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LINES_REJECTED</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>ERRORS</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>ERRORS</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LOG_FIELD</id>\n" +
                                                "          <enabled>N</enabled>\n" +
                                                "          <name>LOG_FIELD</name>\n" +
                                                "        </field>\n" +
                                                "      </step-log-table>\n" +
                                                "      <metrics-log-table>\n" +
                                                "        <connection />\n" +
                                                "        <schema />\n" +
                                                "        <table />\n" +
                                                "        <timeout_days />\n" +
                                                "        <field>\n" +
                                                "          <id>ID_BATCH</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>ID_BATCH</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>CHANNEL_ID</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>CHANNEL_ID</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>LOG_DATE</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>LOG_DATE</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>METRICS_DATE</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>METRICS_DATE</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>METRICS_CODE</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>METRICS_CODE</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>METRICS_DESCRIPTION</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>METRICS_DESCRIPTION</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>METRICS_SUBJECT</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>METRICS_SUBJECT</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>METRICS_TYPE</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>METRICS_TYPE</name>\n" +
                                                "        </field>\n" +
                                                "        <field>\n" +
                                                "          <id>METRICS_VALUE</id>\n" +
                                                "          <enabled>Y</enabled>\n" +
                                                "          <name>METRICS_VALUE</name>\n" +
                                                "        </field>\n" +
                                                "      </metrics-log-table>\n" +
                                                "    </log>\n" +
                                                "    <maxdate>\n" +
                                                "      <connection />\n" +
                                                "      <table />\n" +
                                                "      <field />\n" +
                                                "      <offset>0.0</offset>\n" +
                                                "      <maxdiff>0.0</maxdiff>\n" +
                                                "    </maxdate>\n" +
                                                "    <size_rowset>10000</size_rowset>\n" +
                                                "    <sleep_time_empty>50</sleep_time_empty>\n" +
                                                "    <sleep_time_full>50</sleep_time_full>\n" +
                                                "    <unique_connections>N</unique_connections>\n" +
                                                "    <feedback_shown>Y</feedback_shown>\n" +
                                                "    <feedback_size>50000</feedback_size>\n" +
                                                "    <using_thread_priorities>Y</using_thread_priorities>\n" +
                                                "    <shared_objects_file />\n" +
                                                "    <capture_step_performance>N</capture_step_performance>\n" +
                                                "    <step_performance_capturing_delay>1000</step_performance_capturing_delay>\n" +
                                                "    <step_performance_capturing_size_limit>100</step_performance_capturing_size_limit>\n" +
                                                "    <dependencies>\n" +
                                                "    </dependencies>\n" +
                                                "    <partitionschemas>\n" +
                                                "    </partitionschemas>\n" +
                                                "    <slaveservers>\n" +
                                                "    </slaveservers>\n" +
                                                "    <clusterschemas>\n" +
                                                "    </clusterschemas>\n" +
                                                "    <created_user>-</created_user>\n" +
                                                "    <created_date>2021/06/09 10:52:34.559</created_date>\n" +
                                                "    <modified_user>-</modified_user>\n" +
                                                "    <modified_date>2021/06/09 10:52:34.559</modified_date>\n" +
                                                "    <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key>\n" +
                                                "    <is_key_private>N</is_key_private>\n" +
                                                "  </info>\n" +
                                                "  <notepads>\n" +
                                                "  </notepads>\n" +
                                                "  <connection>\n" +
                                                "    <name>10.58.22.89 data_collection</name>\n" +
                                                "    <server>10.58.22.89</server>\n" +
                                                "    <type>MYSQL</type>\n" +
                                                "    <access>Native</access>\n" +
                                                "    <database>data_collection</database>\n" +
                                                "    <port>3306</port>\n" +
                                                "    <username>dsp</username>\n" +
                                                "    <password>Encrypted 2be98afc86aa7b697bb39ff228dc6fa8c</password>\n" +
                                                "    <servername />\n" +
                                                "    <data_tablespace />\n" +
                                                "    <index_tablespace />\n" +
                                                "    <attributes>\n" +
                                                "      <attribute>\n" +
                                                "        <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code>\n" +
                                                "        <attribute>N</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code>\n" +
                                                "        <attribute>N</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>IS_CLUSTERED</code>\n" +
                                                "        <attribute>N</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>PORT_NUMBER</code>\n" +
                                                "        <attribute>3306</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>PRESERVE_RESERVED_WORD_CASE</code>\n" +
                                                "        <attribute>Y</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>QUOTE_ALL_FIELDS</code>\n" +
                                                "        <attribute>N</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>STREAM_RESULTS</code>\n" +
                                                "        <attribute>Y</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>\n" +
                                                "        <attribute>Y</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>\n" +
                                                "        <attribute>Y</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>USE_POOLING</code>\n" +
                                                "        <attribute>N</attribute>\n" +
                                                "      </attribute>\n" +
                                                "    </attributes>\n" +
                                                "  </connection>\n" +
                                                "  <connection>\n" +
                                                "    <name>10.58.22.89 dw_groupies_cs</name>\n" +
                                                "    <server>10.58.22.89</server>\n" +
                                                "    <type>MYSQL</type>\n" +
                                                "    <access>Native</access>\n" +
                                                "    <database>dw_groupies_cs</database>\n" +
                                                "    <port>3306</port>\n" +
                                                "    <username>dsp</username>\n" +
                                                "    <password>Encrypted 2be98afc86aa7b697bb39ff228dc6fa8c</password>\n" +
                                                "    <servername />\n" +
                                                "    <data_tablespace />\n" +
                                                "    <index_tablespace />\n" +
                                                "    <attributes>\n" +
                                                "      <attribute>\n" +
                                                "        <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code>\n" +
                                                "        <attribute>N</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code>\n" +
                                                "        <attribute>N</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>IS_CLUSTERED</code>\n" +
                                                "        <attribute>N</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>PORT_NUMBER</code>\n" +
                                                "        <attribute>3306</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>PRESERVE_RESERVED_WORD_CASE</code>\n" +
                                                "        <attribute>Y</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>QUOTE_ALL_FIELDS</code>\n" +
                                                "        <attribute>N</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>STREAM_RESULTS</code>\n" +
                                                "        <attribute>Y</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>\n" +
                                                "        <attribute>Y</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>\n" +
                                                "        <attribute>Y</attribute>\n" +
                                                "      </attribute>\n" +
                                                "      <attribute>\n" +
                                                "        <code>USE_POOLING</code>\n" +
                                                "        <attribute>N</attribute>\n" +
                                                "      </attribute>\n" +
                                                "    </attributes>\n" +
                                                "  </connection>\n" +
                                                "  <order>\n" +
                                                "    <hop>\n" +
                                                "      <from>表输入</from>\n" +
                                                "      <to>表输出</to>\n" +
                                                "      <enabled>Y</enabled>\n" +
                                                "    </hop>\n" +
                                                "    <hop>\n" +
                                                "      <from>执行SQL脚本</from>\n" +
                                                "      <to>表输入</to>\n" +
                                                "      <enabled>Y</enabled>\n" +
                                                "    </hop>\n" +
                                                "  </order>\n" +
                                                "  <step>\n" +
                                                "    <name>执行SQL脚本</name>\n" +
                                                "    <type>ExecSQL</type>\n" +
                                                "    <description />\n" +
                                                "    <distribute>Y</distribute>\n" +
                                                "    <custom_distribution />\n" +
                                                "    <copies>1</copies>\n" +
                                                "    <partitioning>\n" +
                                                "      <method>none</method>\n" +
                                                "      <schema_name />\n" +
                                                "    </partitioning>\n" +
                                                "    <connection>10.58.22.89 dw_groupies_cs</connection>\n" +
                                                "    <execute_each_row>N</execute_each_row>\n" +
                                                "    <single_statement>N</single_statement>\n" +
                                                "    <replace_variables>N</replace_variables>\n" +
                                                "    <quoteString>N</quoteString>\n" +
                                                "    <sql>DELETE FROM ${TABLE_NAME} \n" +
                                                "\n" +
                                                "WHERE dsp_row_time >= CURRENT_DATE\n" +
                                                "</sql>\n" +
                                                "    <set_params>N</set_params>\n" +
                                                "    <insert_field />\n" +
                                                "    <update_field />\n" +
                                                "    <delete_field />\n" +
                                                "    <read_field />\n" +
                                                "    <arguments>\n" +
                                                "    </arguments>\n" +
                                                "    <cluster_schema />\n" +
                                                "    <remotesteps>\n" +
                                                "      <input>\n" +
                                                "      </input>\n" +
                                                "      <output>\n" +
                                                "      </output>\n" +
                                                "    </remotesteps>\n" +
                                                "    <GUI>\n" +
                                                "      <xloc>176</xloc>\n" +
                                                "      <yloc>272</yloc>\n" +
                                                "      <draw>Y</draw>\n" +
                                                "    </GUI>\n" +
                                                "  </step>\n" +
                                                "  <step>\n" +
                                                "    <name>表输入</name>\n" +
                                                "    <type>TableInput</type>\n" +
                                                "    <description />\n" +
                                                "    <distribute>Y</distribute>\n" +
                                                "    <custom_distribution />\n" +
                                                "    <copies>1</copies>\n" +
                                                "    <partitioning>\n" +
                                                "      <method>none</method>\n" +
                                                "      <schema_name />\n" +
                                                "    </partitioning>\n" +
                                                "    <connection>10.58.22.89 data_collection</connection>\n" +
                                                "    <sql>SELECT * FROM ${TABLE_NAME} \n" +
                                                "\n" +
                                                "WHERE dsp_row_time >= CURRENT_DATE\n" +
                                                "</sql>\n" +
                                                "    <limit>0</limit>\n" +
                                                "    <lookup />\n" +
                                                "    <execute_each_row>N</execute_each_row>\n" +
                                                "    <variables_active>N</variables_active>\n" +
                                                "    <lazy_conversion_active>N</lazy_conversion_active>\n" +
                                                "    <cluster_schema />\n" +
                                                "    <remotesteps>\n" +
                                                "      <input>\n" +
                                                "      </input>\n" +
                                                "      <output>\n" +
                                                "      </output>\n" +
                                                "    </remotesteps>\n" +
                                                "    <GUI>\n" +
                                                "      <xloc>336</xloc>\n" +
                                                "      <yloc>272</yloc>\n" +
                                                "      <draw>Y</draw>\n" +
                                                "    </GUI>\n" +
                                                "  </step>\n" +
                                                "  <step>\n" +
                                                "    <name>表输出</name>\n" +
                                                "    <type>TableOutput</type>\n" +
                                                "    <description />\n" +
                                                "    <distribute>Y</distribute>\n" +
                                                "    <custom_distribution />\n" +
                                                "    <copies>1</copies>\n" +
                                                "    <partitioning>\n" +
                                                "      <method>none</method>\n" +
                                                "      <schema_name />\n" +
                                                "    </partitioning>\n" +
                                                "    <connection>10.58.22.89 dw_groupies_cs</connection>\n" +
                                                "    <schema />\n" +
                                                "    <table>${TABLE_NAME}</table>\n" +
                                                "    <commit>1000</commit>\n" +
                                                "    <truncate>N</truncate>\n" +
                                                "    <ignore_errors>N</ignore_errors>\n" +
                                                "    <use_batch>Y</use_batch>\n" +
                                                "    <specify_fields>N</specify_fields>\n" +
                                                "    <partitioning_enabled>N</partitioning_enabled>\n" +
                                                "    <partitioning_field />\n" +
                                                "    <partitioning_daily>N</partitioning_daily>\n" +
                                                "    <partitioning_monthly>Y</partitioning_monthly>\n" +
                                                "    <tablename_in_field>N</tablename_in_field>\n" +
                                                "    <tablename_field />\n" +
                                                "    <tablename_in_table>Y</tablename_in_table>\n" +
                                                "    <return_keys>N</return_keys>\n" +
                                                "    <return_field />\n" +
                                                "    <fields>\n" +
                                                "    </fields>\n" +
                                                "    <cluster_schema />\n" +
                                                "    <remotesteps>\n" +
                                                "      <input>\n" +
                                                "      </input>\n" +
                                                "      <output>\n" +
                                                "      </output>\n" +
                                                "    </remotesteps>\n" +
                                                "    <GUI>\n" +
                                                "      <xloc>592</xloc>\n" +
                                                "      <yloc>272</yloc>\n" +
                                                "      <draw>Y</draw>\n" +
                                                "    </GUI>\n" +
                                                "  </step>\n" +
                                                "  <step_error_handling>\n" +
                                                "  </step_error_handling>\n" +
                                                "  <slave-step-copy-partition-distribution>\n" +
                                                "  </slave-step-copy-partition-distribution>\n" +
                                                "  <slave_transformation>N</slave_transformation>\n" +
                                                "</transformation>\n";
    public static String ktrSourceProduction ="<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n" +
                                                      "<transformation>\n" +
                                                      "  <info>\n" +
                                                      "    <name>${TABLE_NAME}</name>\n" +
                                                      "    <description />\n" +
                                                      "    <extended_description />\n" +
                                                      "    <trans_version />\n" +
                                                      "    <trans_type>Normal</trans_type>\n" +
                                                      "    <trans_status>0</trans_status>\n" +
                                                      "    <directory>/</directory>\n" +
                                                      "    <parameters>\n" +
                                                      "    </parameters>\n" +
                                                      "    <log>\n" +
                                                      "      <trans-log-table>\n" +
                                                      "        <connection />\n" +
                                                      "        <schema />\n" +
                                                      "        <table />\n" +
                                                      "        <size_limit_lines />\n" +
                                                      "        <interval />\n" +
                                                      "        <timeout_days />\n" +
                                                      "        <field>\n" +
                                                      "          <id>ID_BATCH</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>ID_BATCH</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>CHANNEL_ID</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>CHANNEL_ID</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>TRANSNAME</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>TRANSNAME</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>STATUS</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>STATUS</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_READ</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_READ</name>\n" +
                                                      "          <subject />\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_WRITTEN</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_WRITTEN</name>\n" +
                                                      "          <subject />\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_UPDATED</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_UPDATED</name>\n" +
                                                      "          <subject />\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_INPUT</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_INPUT</name>\n" +
                                                      "          <subject />\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_OUTPUT</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_OUTPUT</name>\n" +
                                                      "          <subject />\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_REJECTED</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_REJECTED</name>\n" +
                                                      "          <subject />\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>ERRORS</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>ERRORS</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>STARTDATE</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>STARTDATE</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>ENDDATE</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>ENDDATE</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LOGDATE</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LOGDATE</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>DEPDATE</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>DEPDATE</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>REPLAYDATE</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>REPLAYDATE</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LOG_FIELD</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LOG_FIELD</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>EXECUTING_SERVER</id>\n" +
                                                      "          <enabled>N</enabled>\n" +
                                                      "          <name>EXECUTING_SERVER</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>EXECUTING_USER</id>\n" +
                                                      "          <enabled>N</enabled>\n" +
                                                      "          <name>EXECUTING_USER</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>CLIENT</id>\n" +
                                                      "          <enabled>N</enabled>\n" +
                                                      "          <name>CLIENT</name>\n" +
                                                      "        </field>\n" +
                                                      "      </trans-log-table>\n" +
                                                      "      <perf-log-table>\n" +
                                                      "        <connection />\n" +
                                                      "        <schema />\n" +
                                                      "        <table />\n" +
                                                      "        <interval />\n" +
                                                      "        <timeout_days />\n" +
                                                      "        <field>\n" +
                                                      "          <id>ID_BATCH</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>ID_BATCH</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>SEQ_NR</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>SEQ_NR</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LOGDATE</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LOGDATE</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>TRANSNAME</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>TRANSNAME</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>STEPNAME</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>STEPNAME</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>STEP_COPY</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>STEP_COPY</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_READ</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_READ</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_WRITTEN</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_WRITTEN</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_UPDATED</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_UPDATED</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_INPUT</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_INPUT</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_OUTPUT</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_OUTPUT</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_REJECTED</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_REJECTED</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>ERRORS</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>ERRORS</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>INPUT_BUFFER_ROWS</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>INPUT_BUFFER_ROWS</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>OUTPUT_BUFFER_ROWS</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>OUTPUT_BUFFER_ROWS</name>\n" +
                                                      "        </field>\n" +
                                                      "      </perf-log-table>\n" +
                                                      "      <channel-log-table>\n" +
                                                      "        <connection />\n" +
                                                      "        <schema />\n" +
                                                      "        <table />\n" +
                                                      "        <timeout_days />\n" +
                                                      "        <field>\n" +
                                                      "          <id>ID_BATCH</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>ID_BATCH</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>CHANNEL_ID</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>CHANNEL_ID</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LOG_DATE</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LOG_DATE</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LOGGING_OBJECT_TYPE</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LOGGING_OBJECT_TYPE</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>OBJECT_NAME</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>OBJECT_NAME</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>OBJECT_COPY</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>OBJECT_COPY</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>REPOSITORY_DIRECTORY</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>REPOSITORY_DIRECTORY</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>FILENAME</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>FILENAME</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>OBJECT_ID</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>OBJECT_ID</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>OBJECT_REVISION</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>OBJECT_REVISION</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>PARENT_CHANNEL_ID</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>PARENT_CHANNEL_ID</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>ROOT_CHANNEL_ID</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>ROOT_CHANNEL_ID</name>\n" +
                                                      "        </field>\n" +
                                                      "      </channel-log-table>\n" +
                                                      "      <step-log-table>\n" +
                                                      "        <connection />\n" +
                                                      "        <schema />\n" +
                                                      "        <table />\n" +
                                                      "        <timeout_days />\n" +
                                                      "        <field>\n" +
                                                      "          <id>ID_BATCH</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>ID_BATCH</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>CHANNEL_ID</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>CHANNEL_ID</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LOG_DATE</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LOG_DATE</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>TRANSNAME</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>TRANSNAME</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>STEPNAME</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>STEPNAME</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>STEP_COPY</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>STEP_COPY</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_READ</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_READ</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_WRITTEN</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_WRITTEN</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_UPDATED</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_UPDATED</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_INPUT</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_INPUT</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_OUTPUT</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_OUTPUT</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LINES_REJECTED</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LINES_REJECTED</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>ERRORS</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>ERRORS</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LOG_FIELD</id>\n" +
                                                      "          <enabled>N</enabled>\n" +
                                                      "          <name>LOG_FIELD</name>\n" +
                                                      "        </field>\n" +
                                                      "      </step-log-table>\n" +
                                                      "      <metrics-log-table>\n" +
                                                      "        <connection />\n" +
                                                      "        <schema />\n" +
                                                      "        <table />\n" +
                                                      "        <timeout_days />\n" +
                                                      "        <field>\n" +
                                                      "          <id>ID_BATCH</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>ID_BATCH</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>CHANNEL_ID</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>CHANNEL_ID</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>LOG_DATE</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>LOG_DATE</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>METRICS_DATE</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>METRICS_DATE</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>METRICS_CODE</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>METRICS_CODE</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>METRICS_DESCRIPTION</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>METRICS_DESCRIPTION</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>METRICS_SUBJECT</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>METRICS_SUBJECT</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>METRICS_TYPE</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>METRICS_TYPE</name>\n" +
                                                      "        </field>\n" +
                                                      "        <field>\n" +
                                                      "          <id>METRICS_VALUE</id>\n" +
                                                      "          <enabled>Y</enabled>\n" +
                                                      "          <name>METRICS_VALUE</name>\n" +
                                                      "        </field>\n" +
                                                      "      </metrics-log-table>\n" +
                                                      "    </log>\n" +
                                                      "    <maxdate>\n" +
                                                      "      <connection />\n" +
                                                      "      <table />\n" +
                                                      "      <field />\n" +
                                                      "      <offset>0.0</offset>\n" +
                                                      "      <maxdiff>0.0</maxdiff>\n" +
                                                      "    </maxdate>\n" +
                                                      "    <size_rowset>10000</size_rowset>\n" +
                                                      "    <sleep_time_empty>50</sleep_time_empty>\n" +
                                                      "    <sleep_time_full>50</sleep_time_full>\n" +
                                                      "    <unique_connections>N</unique_connections>\n" +
                                                      "    <feedback_shown>Y</feedback_shown>\n" +
                                                      "    <feedback_size>50000</feedback_size>\n" +
                                                      "    <using_thread_priorities>Y</using_thread_priorities>\n" +
                                                      "    <shared_objects_file />\n" +
                                                      "    <capture_step_performance>N</capture_step_performance>\n" +
                                                      "    <step_performance_capturing_delay>1000</step_performance_capturing_delay>\n" +
                                                      "    <step_performance_capturing_size_limit>100</step_performance_capturing_size_limit>\n" +
                                                      "    <dependencies>\n" +
                                                      "    </dependencies>\n" +
                                                      "    <partitionschemas>\n" +
                                                      "    </partitionschemas>\n" +
                                                      "    <slaveservers>\n" +
                                                      "    </slaveservers>\n" +
                                                      "    <clusterschemas>\n" +
                                                      "    </clusterschemas>\n" +
                                                      "    <created_user>-</created_user>\n" +
                                                      "    <created_date>2021/06/09 10:52:34.559</created_date>\n" +
                                                      "    <modified_user>-</modified_user>\n" +
                                                      "    <modified_date>2021/06/09 10:52:34.559</modified_date>\n" +
                                                      "    <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key>\n" +
                                                      "    <is_key_private>N</is_key_private>\n" +
                                                      "  </info>\n" +
                                                      "  <notepads>\n" +
                                                      "  </notepads>\n" +
                                                      "  <connection>\n" +
                                                      "    <name>10.58.22.89 data_collection</name>\n" +
                                                      "    <server>10.58.22.89</server>\n" +
                                                      "    <type>MYSQL</type>\n" +
                                                      "    <access>Native</access>\n" +
                                                      "    <database>data_collection</database>\n" +
                                                      "    <port>3306</port>\n" +
                                                      "    <username>dsp</username>\n" +
                                                      "    <password>Encrypted 2be98afc86aa7b697bb39ff228dc6fa8c</password>\n" +
                                                      "    <servername />\n" +
                                                      "    <data_tablespace />\n" +
                                                      "    <index_tablespace />\n" +
                                                      "    <attributes>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code>\n" +
                                                      "        <attribute>N</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code>\n" +
                                                      "        <attribute>N</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>IS_CLUSTERED</code>\n" +
                                                      "        <attribute>N</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>PORT_NUMBER</code>\n" +
                                                      "        <attribute>3306</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>PRESERVE_RESERVED_WORD_CASE</code>\n" +
                                                      "        <attribute>Y</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>QUOTE_ALL_FIELDS</code>\n" +
                                                      "        <attribute>N</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>STREAM_RESULTS</code>\n" +
                                                      "        <attribute>Y</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>\n" +
                                                      "        <attribute>Y</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>\n" +
                                                      "        <attribute>Y</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>USE_POOLING</code>\n" +
                                                      "        <attribute>N</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "    </attributes>\n" +
                                                      "  </connection>\n" +
                                                      "  <connection>\n" +
                                                      "    <name>10.58.22.89 dw_groupies</name>\n" +
                                                      "    <server>10.58.22.89</server>\n" +
                                                      "    <type>MYSQL</type>\n" +
                                                      "    <access>Native</access>\n" +
                                                      "    <database>dw_groupies</database>\n" +
                                                      "    <port>3306</port>\n" +
                                                      "    <username>dsp</username>\n" +
                                                      "    <password>Encrypted 2be98afc86aa7b697bb39ff228dc6fa8c</password>\n" +
                                                      "    <servername />\n" +
                                                      "    <data_tablespace />\n" +
                                                      "    <index_tablespace />\n" +
                                                      "    <attributes>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>FORCE_IDENTIFIERS_TO_LOWERCASE</code>\n" +
                                                      "        <attribute>N</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>FORCE_IDENTIFIERS_TO_UPPERCASE</code>\n" +
                                                      "        <attribute>N</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>IS_CLUSTERED</code>\n" +
                                                      "        <attribute>N</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>PORT_NUMBER</code>\n" +
                                                      "        <attribute>3306</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>PRESERVE_RESERVED_WORD_CASE</code>\n" +
                                                      "        <attribute>Y</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>QUOTE_ALL_FIELDS</code>\n" +
                                                      "        <attribute>N</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>STREAM_RESULTS</code>\n" +
                                                      "        <attribute>Y</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>SUPPORTS_BOOLEAN_DATA_TYPE</code>\n" +
                                                      "        <attribute>Y</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>\n" +
                                                      "        <attribute>Y</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "      <attribute>\n" +
                                                      "        <code>USE_POOLING</code>\n" +
                                                      "        <attribute>N</attribute>\n" +
                                                      "      </attribute>\n" +
                                                      "    </attributes>\n" +
                                                      "  </connection>\n" +
                                                      "  <order>\n" +
                                                      "    <hop>\n" +
                                                      "      <from>表输入</from>\n" +
                                                      "      <to>表输出</to>\n" +
                                                      "      <enabled>Y</enabled>\n" +
                                                      "    </hop>\n" +
                                                      "    <hop>\n" +
                                                      "      <from>执行SQL脚本</from>\n" +
                                                      "      <to>表输入</to>\n" +
                                                      "      <enabled>Y</enabled>\n" +
                                                      "    </hop>\n" +
                                                      "  </order>\n" +
                                                      "  <step>\n" +
                                                      "    <name>执行SQL脚本</name>\n" +
                                                      "    <type>ExecSQL</type>\n" +
                                                      "    <description />\n" +
                                                      "    <distribute>Y</distribute>\n" +
                                                      "    <custom_distribution />\n" +
                                                      "    <copies>1</copies>\n" +
                                                      "    <partitioning>\n" +
                                                      "      <method>none</method>\n" +
                                                      "      <schema_name />\n" +
                                                      "    </partitioning>\n" +
                                                      "    <connection>10.58.22.89 dw_groupies</connection>\n" +
                                                      "    <execute_each_row>N</execute_each_row>\n" +
                                                      "    <single_statement>N</single_statement>\n" +
                                                      "    <replace_variables>N</replace_variables>\n" +
                                                      "    <quoteString>N</quoteString>\n" +
                                                      "    <sql>DELETE FROM ${TABLE_NAME} \n" +
                                                      "\n" +
                                                      "WHERE dsp_row_time >= CURRENT_DATE\n" +
                                                      "</sql>\n" +
                                                      "    <set_params>N</set_params>\n" +
                                                      "    <insert_field />\n" +
                                                      "    <update_field />\n" +
                                                      "    <delete_field />\n" +
                                                      "    <read_field />\n" +
                                                      "    <arguments>\n" +
                                                      "    </arguments>\n" +
                                                      "    <cluster_schema />\n" +
                                                      "    <remotesteps>\n" +
                                                      "      <input>\n" +
                                                      "      </input>\n" +
                                                      "      <output>\n" +
                                                      "      </output>\n" +
                                                      "    </remotesteps>\n" +
                                                      "    <GUI>\n" +
                                                      "      <xloc>176</xloc>\n" +
                                                      "      <yloc>272</yloc>\n" +
                                                      "      <draw>Y</draw>\n" +
                                                      "    </GUI>\n" +
                                                      "  </step>\n" +
                                                      "  <step>\n" +
                                                      "    <name>表输入</name>\n" +
                                                      "    <type>TableInput</type>\n" +
                                                      "    <description />\n" +
                                                      "    <distribute>Y</distribute>\n" +
                                                      "    <custom_distribution />\n" +
                                                      "    <copies>1</copies>\n" +
                                                      "    <partitioning>\n" +
                                                      "      <method>none</method>\n" +
                                                      "      <schema_name />\n" +
                                                      "    </partitioning>\n" +
                                                      "    <connection>10.58.22.89 data_collection</connection>\n" +
                                                      "    <sql>SELECT * FROM ${TABLE_NAME} \n" +
                                                      "\n" +
                                                      "WHERE dsp_row_time >= CURRENT_DATE\n" +
                                                      "</sql>\n" +
                                                      "    <limit>0</limit>\n" +
                                                      "    <lookup />\n" +
                                                      "    <execute_each_row>N</execute_each_row>\n" +
                                                      "    <variables_active>N</variables_active>\n" +
                                                      "    <lazy_conversion_active>N</lazy_conversion_active>\n" +
                                                      "    <cluster_schema />\n" +
                                                      "    <remotesteps>\n" +
                                                      "      <input>\n" +
                                                      "      </input>\n" +
                                                      "      <output>\n" +
                                                      "      </output>\n" +
                                                      "    </remotesteps>\n" +
                                                      "    <GUI>\n" +
                                                      "      <xloc>336</xloc>\n" +
                                                      "      <yloc>272</yloc>\n" +
                                                      "      <draw>Y</draw>\n" +
                                                      "    </GUI>\n" +
                                                      "  </step>\n" +
                                                      "  <step>\n" +
                                                      "    <name>表输出</name>\n" +
                                                      "    <type>TableOutput</type>\n" +
                                                      "    <description />\n" +
                                                      "    <distribute>Y</distribute>\n" +
                                                      "    <custom_distribution />\n" +
                                                      "    <copies>1</copies>\n" +
                                                      "    <partitioning>\n" +
                                                      "      <method>none</method>\n" +
                                                      "      <schema_name />\n" +
                                                      "    </partitioning>\n" +
                                                      "    <connection>10.58.22.89 dw_groupies</connection>\n" +
                                                      "    <schema />\n" +
                                                      "    <table>${TABLE_NAME}</table>\n" +
                                                      "    <commit>1000</commit>\n" +
                                                      "    <truncate>N</truncate>\n" +
                                                      "    <ignore_errors>N</ignore_errors>\n" +
                                                      "    <use_batch>Y</use_batch>\n" +
                                                      "    <specify_fields>N</specify_fields>\n" +
                                                      "    <partitioning_enabled>N</partitioning_enabled>\n" +
                                                      "    <partitioning_field />\n" +
                                                      "    <partitioning_daily>N</partitioning_daily>\n" +
                                                      "    <partitioning_monthly>Y</partitioning_monthly>\n" +
                                                      "    <tablename_in_field>N</tablename_in_field>\n" +
                                                      "    <tablename_field />\n" +
                                                      "    <tablename_in_table>Y</tablename_in_table>\n" +
                                                      "    <return_keys>N</return_keys>\n" +
                                                      "    <return_field />\n" +
                                                      "    <fields>\n" +
                                                      "    </fields>\n" +
                                                      "    <cluster_schema />\n" +
                                                      "    <remotesteps>\n" +
                                                      "      <input>\n" +
                                                      "      </input>\n" +
                                                      "      <output>\n" +
                                                      "      </output>\n" +
                                                      "    </remotesteps>\n" +
                                                      "    <GUI>\n" +
                                                      "      <xloc>592</xloc>\n" +
                                                      "      <yloc>272</yloc>\n" +
                                                      "      <draw>Y</draw>\n" +
                                                      "    </GUI>\n" +
                                                      "  </step>\n" +
                                                      "  <step_error_handling>\n" +
                                                      "  </step_error_handling>\n" +
                                                      "  <slave-step-copy-partition-distribution>\n" +
                                                      "  </slave-step-copy-partition-distribution>\n" +
                                                      "  <slave_transformation>N</slave_transformation>\n" +
                                                      "</transformation>\n";

}
